/*-+-*****************************************************************************
 Copyright (C) 2009-2012 Oceanside Software Corporation (R)
 Dallas, Texas

 Author       : Jason T. Brower
 Purpose      : This file is part of a point-of-sale software package
                originally written for Table-Service Restaurants.
              
 Date         : July 8th of 2012
              
 History      : The application that this software file belongs to was 
                written over a 3-Year period.  The first version was written
                in C# .Net 3.5 using Windows Forms.  Being new to .Net at
                the time, I soon learned of Windows Presentation Foundation,
                liked the graphics capabilities and databinding so I
                migrated to WPF.  When the .Net 4.0 framework was released
                the application was migrated from 3.5 to 4.0. Now today,
                .Net 4.5 RC is out and I was already in process of migrating
                before I made this public.
                
Excuse Me     : Please excuse the coding style, it is not representative of
                my typical work.  During the three years I was under a very
                tight budget, constantly running out of funding and was 
                working 18 hour days hyped up on 5-Hour Energy.  The 
                design is not textbook.  It is monolythic because of
                previous issues I will not get into.  There are few comments
                in the code and the ones that are there may be incorrect.
                
What it is not: This is not the exact version that I took through PA-DSS 2.0
                nor is it the exact version running at my customer sites.
                I removed some details for security purposes including some
                encryption algorithms.  The reporting was removed because
                I was including a third party library that cannot be 
                published with this Open Source.
                
What it is    : This application has been running at high volume restaraunts
                for over a year.  It never freezes, crashes or does anything
                unexpected.  So long as it is built, installed and configured
                correctly, it is a strong system that we can all enhance.

Contact       : Please note that I can no longer work for free.  However, you
                can reach me at information@oceansidesw.com.                                                      

*********************************************************************************/

using System;
using System.Collections.Generic;
using System.Data.Objects;
using System.Linq;
using System.Threading.Tasks;
#if _LOCALDB
  using Oceanside.LocalDB;
#else
using Oceanside.RemoteDB;
#endif
namespace Oceanside
{
    public class FixTimePunches : BindInterface
    {
        public FixTimePunches(string name = "")
        {
            Text = name;
        }

        override public void Clicked()
        {
            try
            {
                ReportsWindow.RemoveCustomControl();

                DateTimePicker dtm = new DateTimePicker(false, false, false, true, false, null);
                dtm.ShowDialog();
                if (DateTimePicker.LastResponse == UserResponse.YES)
                {
                    if (DateTimePicker.LastEndSelectedDateTime >= DateTimePicker.LastStartSelectedDateTime)
                    {
                        App.InvokeStartStoryBoard_NOTHROW();
                        start = DateTimePicker.LastStartSelectedDateTime;
                        end = DateTimePicker.LastEndSelectedDateTime;
                        Task.Factory.StartNew(() => GetTimePunches());
                    }
                }
            }
            catch (Exception exc)
            {
                Constants.ErrorDispatcher.Notify(Error.EType.E_REPORT_ERROR, exc);
            }
        }

        static DateTime start;
        static DateTime end;
        private void GetTimePunches()
        {
            try
            {
                using (DominicaEntities context = new DominicaEntities(DominicaEntities.GetEfConString()))
                {

                    start = new DateTime(start.Year, start.Month, start.Day, 0, 0, 0);
                    end = new DateTime(end.Year, end.Month, end.Day, 23, 59, 59);


                    var q = context.TIMESLIPS.Where(timeSlip =>
                                     timeSlip.ClockedIn >=
                                     start && timeSlip.ClockedIn <= end);

                    List<TIMESLIP> timeslips = null;

                    if (q.Any())
                    {
                        var q2 = from ts in q
                                 join ROLE in context.ROLES on ts.RoleId equals ROLE.Id
                                 where ROLE.PAYGRADE.IsSalaried == false
                                 select ts;

                        if (q2.Any())
                        {
                            timeslips = q2.ToList();

                            App.InvokeStopStoryBoard_NOTHROW();

                            Constants.MainDispatcher.BeginInvoke(new Action(() =>
                            {
                                EmployeeTimePunches etp = new EmployeeTimePunches();
                                etp.SetDataContext(timeslips);
                                ReportsWindow.CustomControl = etp;
                                ReportsWindow.MainStackPanel.Children.Add(etp);
                                ReportsWindow.ShowFunctionButtons(false);
                            }));
                        }
                        else
                        {
                            UMD.ShowGuiMessageSTASafe_NOTHROW("There is no data in the period you selected.");
                        }
                    }
                    else
                    {
                        UMD.ShowGuiMessageSTASafe_NOTHROW("There is no data in the period you selected.");
                    }
                }
            }
            catch (Exception exc)
            {
                Constants.ErrorDispatcher.Notify(Error.EType.E_REPORT_ERROR, exc);
            }
        }

        public static void RefreshTimePunches(EmployeeTimePunches etp)
        {
            try
            {
                using (DominicaEntities context = new DominicaEntities(DominicaEntities.GetEfConString()))
                {

                    start = new DateTime(start.Year, start.Month, start.Day, 0, 0, 0);
                    end = new DateTime(end.Year, end.Month, end.Day, 23, 59, 59);


                    var q = context.TIMESLIPS.Where(timeSlip =>
                                     timeSlip.ClockedIn >=
                                     start && timeSlip.ClockedIn <= end);

                    List<TIMESLIP> timeslips = null;

                    if (q.Any())
                    {
                        var q2 = from ts in q
                                 join ROLE in context.ROLES on ts.RoleId equals ROLE.Id
                                 where ROLE.PAYGRADE.IsSalaried == false
                                 select ts;

                        if (q2.Any())
                        {
                            timeslips = q2.ToList();

                            App.InvokeStopStoryBoard_NOTHROW();

                            Constants.MainDispatcher.BeginInvoke(new Action(() =>
                            {
                                etp.SetDataContext(timeslips);
                            }));
                        }
                        else
                        {
                            UMD.ShowGuiMessageSTASafe_NOTHROW("There is no data in the period you selected.");
                        }
                    }
                    else
                    {
                        UMD.ShowGuiMessageSTASafe_NOTHROW("There is no data in the period you selected.");
                    }
                }
            }
            catch (Exception exc)
            {
                Constants.ErrorDispatcher.Notify(Error.EType.E_REPORT_ERROR, exc);
            }
        }
    }
}
